Mega Code Archive - C# Tutorial

ADO Net
1) A connection string using integrated security for Oracle database
2) A connection string without integrated security for Oracle database
3) Accessing Data Values in a DataReader
4) Accessing Data Values in a DataRow Array by column name
5) Accessing Data Values in a DataRow Array by column name and return default value
6) Accessing Data Values in a DataRow Array by index
7) Accessing Data Values in a DataRow Array in a generic way by index
8) Accessing Data Values in a DataRow Array in a generic way by name
9) Accessing Data Values in a DataTable or DataSet
10) Accessing FirstName value in row 3 directly
11) Add an expression column to the table
12) Add parameters to the SqlCommand
13) Add Row to DataTable
14) Add SqlParameter to SqlCommand
15) Adding a Calculated Column to a DataTable
16) Adding a Column to a Child DataTable That Displays Data from the Parent Table
17) Adding a Column to a Parent DataTable That Aggregates a Child Tables Column Values
18) Adding Columns to DataTable
19) Adding Constraint to DataTable
20) Adding Data to MDF file with SqlDataAdapter
21) Adding to DataSet and output to Xml
22) Append columns to DataTable
23) Async Command Object Demo
24) Asynchronous Processing Sql command
25) Attach DataViews to two separate DataGrid controls
26) Batch Update Demo
27) Binding DataSet to DataGrid
28) Binding ListBox to a Database table
29) Build a connection string from component parameters and display it
30) Build SqlConnectionStringBuilder from connection string
31) BuildConnectionString solution
32) Call a stored procedure
33) Call stored procedure
34) Call stored procedure with no parameter
35) Call stored procedure with parameter and return value
36) Call stored procedure with parameters using SqlCommand
37) Call stored procedure with SqlCommand
38) Call storedprocedure and pass in the parameter
39) Call StoredProcedure with input and output parameters
40) Catch exception when calling stored procedure
41) Catch SqlClient SqlException
42) Catch SqlException when opening connection
43) ColumnMappings
44) Command NonQuery
45) Command Parameter
46) CommandReader
47) Connect Table to OleDbCommand using CommandType TableDirect
48) Connect to an Oracle Database using NET data provider for OLE DB
49) Connect to an Oracle Database using OdbcConnection
50) Connect to SQLserver
51) Connect to SqlServer and set the IP Address
52) Connect to SqlServer Named Instance
53) Connect to SqlServer using OdbcConnection
54) Connect to SqlServer using OleDbConnection
55) Connect to SqlServer with Integrated security
56) Connect to SqlServer with password and id
57) Connecting to a Microsoft Access Database
58) Connecting to a Microsoft Excel Workbook
59) Connecting to a Password-Protected Microsoft Access Database
60) Connecting to a Text File
61) Connecting To Access
62) Connecting to an ODBC Data Source
63) Connecting to an OLE DB Data Source
64) Connecting to an Oracle Database with OracleConnection
65) Connection Display
66) Connection event
67) Connection for OleDb
68) Connection Pooling Sample
69) Connection String for Oracle database
70) Convert the result from a query to XML and output
71) Convert the result from a query to XML and output (Disconnected mode)
72) Create a data adapter from select statement and connection string
73) Create a SqlCommand
74) Create and fill the DataRow array
75) Create Database connection from DbProviderFactory
76) Create DataSet and DataTable
77) Create DataViews from DataTable
78) Create SqlCommand with both sql query and connection
79) Creating a DataColumn and Adding It to a DataTable
80) Creating a DataTable and Adding It to a DataSet
81) Creating a Strongly Typed DataSet
82) Creating a Unique Constraint
83) Creating an Autoincrementing Primary Key
84) Creating Connection To ODBC
85) Creating Single- and Multi-Column Primary Keys
86) Creating SQL Connections
87) Data Binding
88) Data binding for Multiple Controls
89) Data Provider Factory
90) Data Reading with SqlDataReader
91) DataGrid Column Asssignment for data binding
92) DataGrid Column Style setting
93) DataGrid data binding
94) DataGrid DataSource Setting
95) DataGrid Relation
96) DataGrid View
97) DataReader has records using HasRows property
98) DataRelation Example
99) DataRow Update
100) DataRowState manipulation
101) DataSet DataTable count
102) DataSet DataTable name
103) DataSet Merge event
104) DataSet Read with SqlDataAdapter
105) DataTableMapping and DataGrid
106) DataView and DataRowView
107) DataView Sorter and Filter
108) Deal with connection exception
109) Deal with OleDbException
110) Define DataRelation
111) Delete command with parameters
112) Delete data and reload to DataGrid
113) Delete Data using CommandBuilder
114) Delete data using sql statements
115) Deleting Data
116) Determining the Number of Records Returned in a DataReader
117) Display image
118) Do a delete command to Oracle database
119) Do a row count using SqlCommand
120) Do an insert command to Oracle database
121) Do an update to Oracle database
122) Execute Non Query
123) Execute NonQuery Example
124) Execute nonquery to delete a record (row)
125) Execute nonquery to insert a record (row)
126) Execute Scalar
127) Execute Scalar Example
128) Execute Scalar with SqlCommand
129) Execute the command to get Scalar value
130) Execute the scalar SQL statement and store results
131) Execute two sql commands
132) Execute update statement with SqlCommand against MDF file
133) Executing a Parameterized Query with OleDbCommand
134) Executing a Parameterized Query with SqlCommand
135) Executing a Query That Does Not Return a Result Set
136) Executing a Query That Returns a Single Value
137) Executing a Query That Returns Multiple Result Sets with DataSet
138) Executing a Query That Returns Multiple Result Sets with SqlDataReader
139) Executing a SQL Server Scalar-Valued Function
140) Executing a SQL Server Table-Valued Function
141) Explicit Transaction
142) Fill a DataSet
143) Fill a DataSet using DataAdapter and output to console
144) Fill a DataTable using DataAdapter
145) Fill DataSet With SqlDataAdapter
146) Fill ListBox with data from a DataReader
147) Filling a DataTable from the DataRow array using CopyToDataTable()
148) Filling a DataTable from the DataRow array using CopyToDataTable(DataTable, LoadOption)
149) Filter DataTableCollection
150) Filter Sort
151) Find data by primary key, if not found add to database
152) Find Rows In Data
153) For loop over DataRow array
154) Get column value in a row
155) Get connection state and server version
156) Get data by data type using SqlDataReader
157) Get data from IDataReader
158) Get first index in a row
159) Get SchemaTable from OleDbDataReader
160) Get Sql Statistics
161) Get table list
162) Get table schema from SqlDataReader
163) Get the available data provider factories
164) Get the column ordinal for the Phone attribute and use it to output the column
165) Get the list of ADO NET data providers registered in the machine and application configuration file
166) Get value from a row with default value
167) Handle Multiple Results
168) execute multiple SQL statements using a SqlCommand object
169) perform a SELECT statement using ADO NET
170) read a table schema
171) use an OleDbConnection object to connect to an Oracle database
172) use the InfoMessage event
173) Implicit Transaction
174) Insert command with parameters
175) Insert Data and reload to DataGrid
176) Insert Data using SqlCommandBuilder
177) Inserting Data Using SQLStatements
178) Inserts (create) a new table
179) Link two DataTable in a DataGrid
180) Listen to Connection state changed event
181) Load data from a select statement to DataGrid
182) Load data in DataTable to DataGrid
183) Load Data to DataGrid
184) Load image to database
185) Load Text file to Database
186) Load XML to DataSet
187) LoadImages cs
188) Loop through all errors
189) Loop through DataRowView in DataView
190) Loop through DataTable by DataRow
191) Loop through the rows in DataTable
192) Manual Loopup for Oracle database
193) Mapping NET Data Provider Data Types to NET Framework Data Types by calling the GetXXX method
194) Mapping NET Data Provider Data Types to NET Framework Data Types by casting
195) Mapping NET Data Provider Data Types to NET Framework Data Types by converting
196) Mapping Table and Column Names Between a Data Source and DataSet
197) Merge two DataSet
198) Modify DataTable
199) Multiple Data View
200) Multiple DataAdapter
201) Multitabled DataSet App
202) Navigate a many-to-many relationship
203) Navigating Between Parent and Child Tables in an Untyped DataSet
204) Nested Implicit Transaction
205) No Connection Pooling
206) Obtain a nonpooled connection
207) Obtain a pooled connection
208) Obtain the DataTable of SQL Server instances and display the list of the SQL Servers
209) Obtain the DbProviderFactory for SQL Server and create connection from it
210) ODBC MySqlConnection
211) Odbc Provider
212) OdbcConnection for Access mdb file
213) OleDbCommand
214) OleDbConnection connection state
215) OleDbDataAdapter and SqlDataAdapter
216) OleDbParameter Example
217) OleDbProvider
218) Opens and verifies a connection
219) Ordinal Indexer
220) Ordinal Indexer demo
221) Output Constraint Properties
222) Output DataSet as Binary file
223) Output fields from DataReader row
224) Output properties for OleDbConnection
225) Output the rows from the DataTable with foreach loop over DataRowCollection
226) Output the XSD schema for the DataSet
227) Pass value to SqlCommand with SqlParameter
228) Passing a Null Value to a Query Parameter
229) Persist a Dataset to an XML file
230) Persist Adds
231) Persist Adds Builder
232) Persist Changes
233) Persist Deletes
234) Pop DataSet
235) Pop DataTable
236) Programmatic Data Display
237) Properties of SqlConnection
238) Raising and Handling Stored Procedure Errors
239) Read an xml file into a dataset
240) Read Bitmap from database
241) Read data from Access database
242) Read data from database table add it to a ListBox
243) Read decimal from OracleDataReader
244) Read result set from OdbcDataReader
245) Read result set from OleDbDataReader
246) Read resultset from a combined queries
247) Read schema and reload data with DataSet
248) Read string from OracleDataReader
249) Reading Access Data with OleDbConnection
250) Reference result set by column index in SqlDataReader
251) Reference result set by column name in SqlDataReader
252) ResultSet Info
253) ResultSet Metadata
254) Retrieves a list of tables in a database
255) Retrieves a schema table for a query
256) Retrieves data as native SQL Server types
257) Retrieves stored procedure parameter information
258) Retrieving a Result Set Stream Using a DataReader
259) Retrieving a Result Set Using a DataTable or a DataSet
260) Retrieving a Return Value from a Stored Procedure
261) Retrieving a Stored Procedure Output Parameter
262) Retrieving Data from a Microsoft Excel Workbook
263) Retrieving Data from a Text File
264) Retrieving Data Using a SQL Server Stored Procedure
265) Retrieving Schema and Constraints for a DataSet
266) Rollback for Oracle database
267) Runs the CustomerAdd stored procedure
268) Save data stored in table to xml file
269) Save DataSet to disk with schema
270) Save result from SqlXmlCommand to xml file
271) Save text from database to text file
272) Schema Table from SqlDataReader
273) Set AttachDbFilename in connection string
274) Set auto increment, seed and step for primary key column
275) Setting Connection Pooling Options
276) Show SQL
277) Show SQL from SqlCommandBuilder
278) Show the connection properties for SqlConnection
279) Simple Query
280) Simple Query Dataset
281) SQL StoredProcedure
282) SqlCommand
283) SqlCommand ExecuteXmlReader
284) SqlCommand with Callback Handler
285) SqlConnection connection state
286) SqlDataReader
287) SqlDataReader GetString, GetDateTime
288) SqlXmlCommand and Xsl
289) Start process of retrieving a data reader asynchronously, check the IsCompleted property value
290) Table mapping
291) The use of a transaction
292) Transform Data
293) Typed Accessors
294) Update command with parameters
295) Update data and reload to DataGrid
296) Update data using SQL update clause
297) Update SqlDataAdapter with DataSet
298) Update through SqlDataAdapter
299) Updating a DataSource
300) Updating Data Using CommondBuilder
301) Updating Data Using Sql Statements
302) Updating Data Using Transactions
303) Updating Data with SqlDataAdapter and DataSet
304) Use a DataAdapter to fill a DataTable
305) Use a relationship with a calculated column
306) Use an OleDbCommand object to read data from Access database
307) Use DataTable to insert a Row
308) Use indexer to read data
309) Use loop to read all data in SqlDataReader
310) Use ODBC Data Provider
311) Use OdbcDataAdapter to read data from ODBC MySql connection
312) Use OLE DB Data Provider
313) Use OleDbCommand to load data from Access database mdb
314) Use OracleConnection to connect to Oracle database
315) Use SQL Server Data Provider
316) Use SqlBulkCopy to data from one table to another table
317) Use SqlDataAdapter to deal with the select statement
318) Use SqlDataReader to retrieve data in the resultset
319) Use StreamWriter to read result from SqlXmlCommand
320) Use to OleDbDataReader retrieve data
321) Using a DataReader to read row by row
322) Using ADO Managed Provider
323) Using ADO NET Events
324) Using DataTable Mappings
325) Using foreach statement with DataRow in DataTable
326) Using MultiTabled Datasets
327) Using OracleCommand to do query
328) Using OracleCommand to do the query sql
329) Using OracleCommandBuilder
330) Using OracleDataAdapter
331) Using OracleDataReader to read from Oracle database
332) Using OracleParameter
333) Using SqlXmlParameter
334) Write Xml
335) Writes binary data to a file